-- =============================================
-- Author:		Deyvison Souto
-- Create date: 08/09/2013
-- Description:	Gravar Academia
-- =============================================
CREATE PROCEDURE ai_sp_listarAcademia 
AS
BEGIN

SELECT [id]
      ,[razao_social]
      ,[fantasia]
      ,[cnpj]
      ,[cep]
      ,[endereco]
      ,[numero]
      ,[complemento]
      ,[bairro]
      ,[cidade]
      ,[estado]
      ,[data_inclusao]
      ,[ativo]
  FROM [dbo].[Academia]
  where ativo = 1

END
GO
